Schema security
Schema security ensures that only authorized users can modify table, field, and index definitions. To establish schema security, use the Data Dictionary Freeze/Unfreeze utility to lock or freeze table, field, and index definitions in the database so that unauthorized users cannot make any modifications to them. Schema modifications change file time stamps, or cyclic redundancy check (CRC) values, making all procedures that reference the database invalid. After you freeze a database, no user can make any changes to it.
You can unfreeze frozen tables when you have to make changes, such as adding or deleting fields or indexes or modifying field or index definitions.
|
To freeze or unfreeze a table: |
- Access the Data Administration tool if you are using a graphical interface or access the Data Dictionary if you are using a character interface.
- Choose Utilities
Freeze/Unfreeze. The Data tool alphabetically lists the tables defined for the working database. - Choose the table you want to freeze or unfreeze. The Freeze/Unfreeze Table dialog box appears:
- Specify the table status, then choose OK.
As security administrator, you can control which users have authority to freeze or unfreeze database tables. To freeze or unfreeze tables, the user must have can-write access to the _File table and can-write access to the _File_Frozen field.